Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | CostValuationLedgerAccount(LE_STKACT_CST) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
RevenueCostCenterID (FK)(PK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | CostValuationLedgerAccount(LE_STKACT_CST) |
CumulativeReceivedCostAmount | The cumulative cost value of units received by the MerchandisingRevenueCenter since the beginning of the historical ReportingPeriod. This figure is used to update the AverageWeightedUnitCost of Items during the ReportingPeriod. | TC_RCV_CM | Money | decimal(16,5) | |
BeginningAverageWeightedUnitCost | The current weighted average cost for each retail sale unit of this item at the beginning of the historical ReportingPeriod. | CP_UN_AV_WT_BGN | MoneyShortCost | decimal(16,5) | |
EndingAverageWeightedUnitCost | The current weighted average cost for each retail sale unit of this item at the end of the historical ReportingPeriod. | CP_UN_AV_WT_END | MoneyShortCost | decimal(16,5) | |